﻿using System;
using System.Data;
using System.Collections;
using System.Collections.Specialized;
using WP.DB;
using WP.RM.DataEntity;
using WP.Commons;

namespace WP.RM.DataAccess
{
    public class RMWorkerDAL  : IDataAccess
    {
        public RMWorkerDAL()
		{
		}
        #region Select List
        public string SQLList(int iParameter)
        {
            string strSQL = @"SELECT RecId,WorkerID,WorkerName,NamePY,WorkShopSeqNo,WorkShopName,WorkPositionSeqNo,WorkPositionName,WorkingProcedureID,WorkingProcedureName
                             ,BeginDate,STDSalary,PrdSalary,DftWorkDays,SalaryRate,STDWorkSalary
                             ,EndowmentIns,EndowmentInsRate,MedicalIns,MedicalInsRate,UnEmployIns,UnEmployInsRate,Remark FROM rmWorker order by WorkerID ";
            return strSQL;
        }
        #endregion

        #region Fields
        public string Fields
        {
            get
            {
                return @"  WorkerID,WorkerName,NamePY,WorkPositionSeqNo,WorkPositionName,WorkShopSeqNo,WorkShopName,WorkingProcedureID,WorkingProcedureName
                           ,BeginDate,STDSalary,PrdSalary,DftWorkDays,SalaryRate,STDWorkSalary
                           ,EndowmentIns,EndowmentInsRate,MedicalIns,MedicalInsRate,UnEmployIns,UnEmployInsRate,Remark,ISDel
                        ";
            }
        }
        #endregion

    }
}
